package com.hospital.hospital.mapper;

import com.hospital.hospital.bean.Drug;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @author xfm
 * @create 2021/9/3
 */
@Mapper
public interface DrugMapper {
    List<Drug> queryAll()throws Exception;
    Drug queryByDname(String dname)throws Exception;
    void reduce(Integer id,Integer num)throws Exception;
    void insert(String dname,Double sprice,Integer num)throws Exception;
    void update(Integer id,Integer num,Double sprice)throws Exception;
    void delete(Integer id)throws Exception;
    Drug queryById(Integer id)throws Exception;
}
